Buffer Zone Analysis of Flock Sites in Cambridge, Massachusetts, USA.

Author

John Arhin

Published

October 19, 2025

Libraries

We load the Python packages needed for our analysis.

Code
# libraries
import pandas as pd
import os
import geopandas as gpd

from geopandas.tools import geocode

Data Preparation

Flock Site Data

We load the data from a text file. We use read the file as a dataframe using a the method in pandas that reads fixed-width files, pandas.read_fwf. See pandas.read_fwf — pandas 2.3.3 documentation for more information. In the method pandas.read_fwf, we use the arguments:

  • width = [5, 70] to specify the column widths in terms of number of characters,
  • header=0 to specifify that there is no header information in the file, and
  • names=["site", "description"] to give the resulting dataframe the column names "site" and "description".
Code
flock_text_file_location = "Flock Sites.txt"

flock_df = pd.read_fwf(
    flock_text_file_location,
    widths = [5, 70],
    header = 0,
    names = ["site", "description"]
)

flock_df
site description
0 P#002 Rindge Ave @ Alewife Brook Pkwy (solar power, ...
1 P#003 Cambridge St @ Hampshire St (solar power, city...
2 F#004 Main St @ Osborn St WB (AC power, city light p...
3 P#005 Cardinal Medeiros Ave@ Binney St (AC power, ci...
4 P#006 Galileo Galilei Way@ Broadway (solar power, ci...
5 P#007 Memorial Dr@ JFK St (solar power, city light p...
6 P#008 Rindge Ave @ Pemberton St (solar power, city l...
7 P#009 Massachusetts Ave @ Memorial Dr (AC power, cit...
8 P#010 Windsor St@ Hampshire St (solar power, city li...
9 P#011 Cambridge St@ N First St (AC power, city light...
10 P#012 Third St @ Gore St (solar power, surface wall ...
11 P#013 Hampshire St@ Cambridge St (solar power, city ...
12 P#014 Main St @ Broadway (solar power, city light pole)
13 P#015 Binney St@ Third St (AC power, city light pole)
14 P#016 Galileo Galilei Way@ Broadway (solar power, ci...

We loop through all of the columns of the dataframe and trim the whitespace.

Code
for col in flock_df.columns:
    flock_df[col].str.strip()

Data Cleaning

We remove the close brackets, and then we split of the characters @ and open brackets ( in order to create columns that extract parts of the flock site address and extra descriptions for the flock sites. In order to create flock site full addresses for a geocoding search we combine the first and seconds parts of the location together with the suffix , Cambridge, MASS, USA.

Code
temp_description_df = flock_df["description"].str.replace(")", "").str.split("@|\(", expand = True, n=2)
temp_description_df
0 1 2
0 Rindge Ave Alewife Brook Pkwy solar power, city traffic signal
1 Cambridge St Hampshire St solar power, city light pole
2 Main St Osborn St WB AC power, city light pole
3 Cardinal Medeiros Ave Binney St AC power, city light pole
4 Galileo Galilei Way Broadway solar power, city light pole
5 Memorial Dr JFK St solar power, city light pole
6 Rindge Ave Pemberton St solar power, city light pole
7 Massachusetts Ave Memorial Dr AC power, city light pole
8 Windsor St Hampshire St solar power, city light pole
9 Cambridge St N First St AC power, city light pole
10 Third St Gore St solar power, surface wall mount
11 Hampshire St Cambridge St solar power, city light pole
12 Main St Broadway solar power, city light pole
13 Binney St Third St AC power, city light pole
14 Galileo Galilei Way Broadway solar power, city light pole
Code
flock_df = flock_df.assign(
    flock_site_address = temp_description_df[0].str.strip().str.cat(
        temp_description_df[1].str.strip(), 
        sep = " & "
    ).str.strip() + ", Cambridge, Massachusetts, USA",
    flock_site_description = temp_description_df[2].str.strip()
)

# delete object
del temp_description_df

flock_df
site description flock_site_address flock_site_description
0 P#002 Rindge Ave @ Alewife Brook Pkwy (solar power, ... Rindge Ave & Alewife Brook Pkwy, Cambridge, Ma... solar power, city traffic signal
1 P#003 Cambridge St @ Hampshire St (solar power, city... Cambridge St & Hampshire St, Cambridge, Massac... solar power, city light pole
2 F#004 Main St @ Osborn St WB (AC power, city light p... Main St & Osborn St WB, Cambridge, Massachuset... AC power, city light pole
3 P#005 Cardinal Medeiros Ave@ Binney St (AC power, ci... Cardinal Medeiros Ave & Binney St, Cambridge, ... AC power, city light pole
4 P#006 Galileo Galilei Way@ Broadway (solar power, ci... Galileo Galilei Way & Broadway, Cambridge, Mas... solar power, city light pole
5 P#007 Memorial Dr@ JFK St (solar power, city light p... Memorial Dr & JFK St, Cambridge, Massachusetts... solar power, city light pole
6 P#008 Rindge Ave @ Pemberton St (solar power, city l... Rindge Ave & Pemberton St, Cambridge, Massachu... solar power, city light pole
7 P#009 Massachusetts Ave @ Memorial Dr (AC power, cit... Massachusetts Ave & Memorial Dr, Cambridge, Ma... AC power, city light pole
8 P#010 Windsor St@ Hampshire St (solar power, city li... Windsor St & Hampshire St, Cambridge, Massachu... solar power, city light pole
9 P#011 Cambridge St@ N First St (AC power, city light... Cambridge St & N First St, Cambridge, Massachu... AC power, city light pole
10 P#012 Third St @ Gore St (solar power, surface wall ... Third St & Gore St, Cambridge, Massachusetts, USA solar power, surface wall mount
11 P#013 Hampshire St@ Cambridge St (solar power, city ... Hampshire St & Cambridge St, Cambridge, Massac... solar power, city light pole
12 P#014 Main St @ Broadway (solar power, city light pole) Main St & Broadway, Cambridge, Massachusetts, USA solar power, city light pole
13 P#015 Binney St@ Third St (AC power, city light pole) Binney St & Third St, Cambridge, Massachusetts... AC power, city light pole
14 P#016 Galileo Galilei Way@ Broadway (solar power, ci... Galileo Galilei Way & Broadway, Cambridge, Mas... solar power, city light pole
Code
geo = geocode(
    flock_df["flock_site_address"], 
    provider="arcgis", 
    user_agent="flock_sites_analysis_ipynb", 
    timeout=10
)
geo.head()
geometry address
0 POINT (-71.14047 42.39407) Rindge Ave & Alewife Brook Pkwy, Cambridge, Ma...
1 POINT (-71.10132 42.37379) Cambridge St & Hampshire St, Cambridge, Massac...
2 POINT (-71.09527 42.3631) Main St & Osborn St, Cambridge, Massachusetts,...
3 POINT (-71.09094 42.36773) Cardinal Medeiros Ave & Binney St, Cambridge, ...
4 POINT (-71.08951 42.36475) Galileo Galilei Way & Broadway, Cambridge, Mas...
Code
flock_gdf = geo.join(flock_df)

# we no longer need flock_df
del flock_df

flock_gdf
geometry address site description flock_site_address flock_site_description
0 POINT (-71.14047 42.39407) Rindge Ave & Alewife Brook Pkwy, Cambridge, Ma... P#002 Rindge Ave @ Alewife Brook Pkwy (solar power, ... Rindge Ave & Alewife Brook Pkwy, Cambridge, Ma... solar power, city traffic signal
1 POINT (-71.10132 42.37379) Cambridge St & Hampshire St, Cambridge, Massac... P#003 Cambridge St @ Hampshire St (solar power, city... Cambridge St & Hampshire St, Cambridge, Massac... solar power, city light pole
2 POINT (-71.09527 42.3631) Main St & Osborn St, Cambridge, Massachusetts,... F#004 Main St @ Osborn St WB (AC power, city light p... Main St & Osborn St WB, Cambridge, Massachuset... AC power, city light pole
3 POINT (-71.09094 42.36773) Cardinal Medeiros Ave & Binney St, Cambridge, ... P#005 Cardinal Medeiros Ave@ Binney St (AC power, ci... Cardinal Medeiros Ave & Binney St, Cambridge, ... AC power, city light pole
4 POINT (-71.08951 42.36475) Galileo Galilei Way & Broadway, Cambridge, Mas... P#006 Galileo Galilei Way@ Broadway (solar power, ci... Galileo Galilei Way & Broadway, Cambridge, Mas... solar power, city light pole
5 POINT (-71.12246 42.36981) Memorial Dr & JFK St, Cambridge, Massachusetts... P#007 Memorial Dr@ JFK St (solar power, city light p... Memorial Dr & JFK St, Cambridge, Massachusetts... solar power, city light pole
6 POINT (-71.1253 42.39258) Rindge Ave & Pemberton St, Cambridge, Massachu... P#008 Rindge Ave @ Pemberton St (solar power, city l... Rindge Ave & Pemberton St, Cambridge, Massachu... solar power, city light pole
7 POINT (-71.09261 42.35729) Massachusetts Ave & Memorial Dr, Cambridge, Ma... P#009 Massachusetts Ave @ Memorial Dr (AC power, cit... Massachusetts Ave & Memorial Dr, Cambridge, Ma... AC power, city light pole
8 POINT (-71.09478 42.36877) Windsor St & Hampshire St, Cambridge, Massachu... P#010 Windsor St@ Hampshire St (solar power, city li... Windsor St & Hampshire St, Cambridge, Massachu... solar power, city light pole
9 POINT (-71.07693 42.37062) Cambridge St & 1st St, Cambridge, Massachusett... P#011 Cambridge St@ N First St (AC power, city light... Cambridge St & N First St, Cambridge, Massachu... AC power, city light pole
10 POINT (-71.0797 42.37172) 3rd St & Gore St, Cambridge, Massachusetts, 02141 P#012 Third St @ Gore St (solar power, surface wall ... Third St & Gore St, Cambridge, Massachusetts, USA solar power, surface wall mount
11 POINT (-71.10132 42.37379) Hampshire St & Cambridge St, Cambridge, Massac... P#013 Hampshire St@ Cambridge St (solar power, city ... Hampshire St & Cambridge St, Cambridge, Massac... solar power, city light pole
12 POINT (-71.08211 42.3621) Main St & Broadway, Cambridge, Massachusetts, ... P#014 Main St @ Broadway (solar power, city light pole) Main St & Broadway, Cambridge, Massachusetts, USA solar power, city light pole
13 POINT (-71.08247 42.36561) Binney St & 3rd St, Cambridge, Massachusetts, ... P#015 Binney St@ Third St (AC power, city light pole) Binney St & Third St, Cambridge, Massachusetts... AC power, city light pole
14 POINT (-71.08951 42.36475) Galileo Galilei Way & Broadway, Cambridge, Mas... P#016 Galileo Galilei Way@ Broadway (solar power, ci... Galileo Galilei Way & Broadway, Cambridge, Mas... solar power, city light pole

Write Flock Site Data to File

We write the flock site data with geocoded information to file.

Code
csv_output_folder = "./CSV Files"

flock_gdf.to_csv(
    os.path.join(
        csv_output_folder,
        "flock_sites_geometries.csv"
    ),
    index = False
)

Data Munging

We use an equal area projection for accuracy. We use the term massachusetts as the search term in EPSG.io Coordinate Systems Worldwide to give EPSG:26987

We consider a buffer of radius 300 feet or 91.4 metres for each Flock Site.

Code
# projection constant
epsg_constant = 26987

# convert using equal area projection
flock_gdf= flock_gdf.to_crs(epsg=epsg_constant)

# buffer length
buffer_length_in_meters = 91.44

# add buffer to geometries
flock_gdf['geometry'] = flock_gdf.geometry.buffer(buffer_length_in_meters)

flock_gdf
geometry address site description flock_site_address flock_site_description
0 POLYGON ((447349.252 155036.532, 447348.812 15... Rindge Ave & Alewife Brook Pkwy, Cambridge, Ma... P#002 Rindge Ave @ Alewife Brook Pkwy (solar power, ... Rindge Ave & Alewife Brook Pkwy, Cambridge, Ma... solar power, city traffic signal
1 POLYGON ((450557.156 152760.721, 450556.716 15... Cambridge St & Hampshire St, Cambridge, Massac... P#003 Cambridge St @ Hampshire St (solar power, city... Cambridge St & Hampshire St, Cambridge, Massac... solar power, city light pole
2 POLYGON ((451047.796 151569.637, 451047.356 15... Main St & Osborn St, Cambridge, Massachusetts,... F#004 Main St @ Osborn St WB (AC power, city light p... Main St & Osborn St WB, Cambridge, Massachuset... AC power, city light pole
3 POLYGON ((451407.899 152081.398, 451407.458 15... Cardinal Medeiros Ave & Binney St, Cambridge, ... P#005 Cardinal Medeiros Ave@ Binney St (AC power, ci... Cardinal Medeiros Ave & Binney St, Cambridge, ... AC power, city light pole
4 POLYGON ((451523.211 151749.047, 451522.771 15... Galileo Galilei Way & Broadway, Cambridge, Mas... P#006 Galileo Galilei Way@ Broadway (solar power, ci... Galileo Galilei Way & Broadway, Cambridge, Mas... solar power, city light pole
5 POLYGON ((448813.069 152330.46, 448812.629 152... Memorial Dr & JFK St, Cambridge, Massachusetts... P#007 Memorial Dr@ JFK St (solar power, city light p... Memorial Dr & JFK St, Cambridge, Massachusetts... solar power, city light pole
6 POLYGON ((448597.443 154861.876, 448597.003 15... Rindge Ave & Pemberton St, Cambridge, Massachu... P#008 Rindge Ave @ Pemberton St (solar power, city l... Rindge Ave & Pemberton St, Cambridge, Massachu... solar power, city light pole
7 POLYGON ((451261.886 150922.732, 451261.446 15... Massachusetts Ave & Memorial Dr, Cambridge, Ma... P#009 Massachusetts Ave @ Memorial Dr (AC power, cit... Massachusetts Ave & Memorial Dr, Cambridge, Ma... AC power, city light pole
8 POLYGON ((451091.878 152198.58, 451091.437 152... Windsor St & Hampshire St, Cambridge, Massachu... P#010 Windsor St@ Hampshire St (solar power, city li... Windsor St & Hampshire St, Cambridge, Massachu... solar power, city light pole
9 POLYGON ((452563.678 152394.273, 452563.237 15... Cambridge St & 1st St, Cambridge, Massachusett... P#011 Cambridge St@ N First St (AC power, city light... Cambridge St & N First St, Cambridge, Massachu... AC power, city light pole
10 POLYGON ((452336.878 152518.331, 452336.437 15... 3rd St & Gore St, Cambridge, Massachusetts, 02141 P#012 Third St @ Gore St (solar power, surface wall ... Third St & Gore St, Cambridge, Massachusetts, USA solar power, surface wall mount
11 POLYGON ((450557.156 152760.721, 450556.716 15... Hampshire St & Cambridge St, Cambridge, Massac... P#013 Hampshire St@ Cambridge St (solar power, city ... Hampshire St & Cambridge St, Cambridge, Massac... solar power, city light pole
12 POLYGON ((452131.18 151450.867, 452130.739 151... Main St & Broadway, Cambridge, Massachusetts, ... P#014 Main St @ Broadway (solar power, city light pole) Main St & Broadway, Cambridge, Massachusetts, USA solar power, city light pole
13 POLYGON ((452104.205 151841.407, 452103.765 15... Binney St & 3rd St, Cambridge, Massachusetts, ... P#015 Binney St@ Third St (AC power, city light pole) Binney St & Third St, Cambridge, Massachusetts... AC power, city light pole
14 POLYGON ((451523.211 151749.047, 451522.771 15... Galileo Galilei Way & Broadway, Cambridge, Mas... P#016 Galileo Galilei Way@ Broadway (solar power, ci... Galileo Galilei Way & Broadway, Cambridge, Mas... solar power, city light pole
Code
flock_gdf.explore(color = "red")
Make this Notebook Trusted to load map: File -> Trust Notebook

Shapefiles

We load the building shapefiles for Cambridge, Mass., sourced from Buildings - GIS - City of Cambridge, Massachusetts.

To save space and memory in our analysis, we only consider the columns for the building identifier “BldgID”, “TYPE” of building and “geommetry” i.e. shape information.

Code
buildings_gdf = gpd.read_file(
    "./Data/BASEMAP_Buildings.shp/BASEMAP_Buildings.shp",
)

We convert the buildings information to use the same equal area projection as epsg_constant = 26987

Code
buildings_gdf = buildings_gdf.to_crs(epsg=epsg_constant)
Code
# convert column to string
buildings_gdf["BldgID"] = buildings_gdf["BldgID"].astype(str)
Code
buildings_gdf.explore(color = "brown")
Make this Notebook Trusted to load map: File -> Trust Notebook

This buildings dataset has a complement address dataset. The full addresses dataset is available from Address Points - GIS - City of Cambridge, Massachusetts.

To save space and memory in our analysis, we only consider the some columns from the address dataset. We will focus on the following columns: * “Full_Addr” for full address, and * “BldgID” for building identifier.

Code
address_df = pd.read_csv("./Data/addresses.csv")
address_df.head()
Full_Addr BldgID
0 18 Clary St 339-23
1 16 Springfield St 343-5
2 26 Soden St 572-6
3 411 Franklin St 558-20
4 348 Franklin St 594-1
Code
# convert column to string
address_df["BldgID"] = address_df["BldgID"].astype(str)

Buffer Zone Analysis

Buildings Within 300 feet of a Flock Site

We use spatial joins to test whether the buildings are within a flock site buffer zone. We then add the full address using the building identifier column “BldgID”.

Code
buildings_within_buffer = gpd.sjoin(
    buildings_gdf, 
    flock_gdf, 
    how = 'inner', 
    predicate = 'within'
).merge(address_df, on = "BldgID", how = "left")
Code
buildings_within_buffer.shape
(369, 20)
Code
buildings_gdf.shape
(18129, 13)
Code
buildings_within_buffer
TYPE BASE_ELEV ELEV_SL TOP_SL ELEV_GL TOP_GL BldgID EditDate created_da last_edite Shape_area Shape_len geometry index_right address site description flock_site_address flock_site_description Full_Addr
0 OUTBLDG 12.2 19.0 19.8 6.8 7.6 999-413 None 2020-04-27 2021-10-20 87.508135 37.605144 POLYGON Z ((450990.335 152252.156 18.965, 4509... 8 Windsor St & Hampshire St, Cambridge, Massachu... P#010 Windsor St@ Hampshire St (solar power, city li... Windsor St & Hampshire St, Cambridge, Massachu... solar power, city light pole NaN
1 OUTBLDG 12.5 19.5 19.8 7.0 7.3 999-418 None 2020-04-27 2021-10-20 59.103156 30.780367 POLYGON Z ((451036.689 152257.485 19.547, 4510... 8 Windsor St & Hampshire St, Cambridge, Massachu... P#010 Windsor St@ Hampshire St (solar power, city li... Windsor St & Hampshire St, Cambridge, Massachu... solar power, city light pole NaN
2 OUTBLDG 12.0 17.5 18.7 5.5 6.7 999-451 None 2020-04-27 2021-10-20 69.773644 33.435409 POLYGON Z ((450982.863 152279.356 17.458, 4509... 8 Windsor St & Hampshire St, Cambridge, Massachu... P#010 Windsor St@ Hampshire St (solar power, city li... Windsor St & Hampshire St, Cambridge, Massachu... solar power, city light pole NaN
3 OUTBLDG 12.1 20.6 20.9 8.5 8.8 999-452 None 2020-04-27 2021-10-20 387.796681 78.787311 POLYGON Z ((450990.604 152278.813 20.645, 4509... 8 Windsor St & Hampshire St, Cambridge, Massachu... P#010 Windsor St@ Hampshire St (solar power, city li... Windsor St & Hampshire St, Cambridge, Massachu... solar power, city light pole NaN
4 OUTBLDG 31.4 37.9 37.4 6.5 6.0 999-690 None 2020-04-27 2021-10-20 59.367898 34.592241 POLYGON Z ((452225.979 152482.858 37.445, 4522... 10 3rd St & Gore St, Cambridge, Massachusetts, 02141 P#012 Third St @ Gore St (solar power, surface wall ... Third St & Gore St, Cambridge, Massachusetts, USA solar power, surface wall mount NaN
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
364 BLDG 8.2 78.8 96.2 70.6 88.0 655-2 2021 2020-04-27 2021-12-28 10739.284329 416.155680 POLYGON Z ((450915.801 151543.605 0.0001, 4509... 2 Main St & Osborn St, Cambridge, Massachusetts,... F#004 Main St @ Osborn St WB (AC power, city light p... Main St & Osborn St WB, Cambridge, Massachuset... AC power, city light pole 730 Main St
365 BLDG 0.0 0.0 0.0 0.0 0.0 59-26 2023 2023-09-19 2023-09-19 13131.598298 556.556741 POLYGON Z ((447275.214 155023.963 0, 447279.89... 0 Rindge Ave & Alewife Brook Pkwy, Cambridge, Ma... P#002 Rindge Ave @ Alewife Brook Pkwy (solar power, ... Rindge Ave & Alewife Brook Pkwy, Cambridge, Ma... solar power, city traffic signal 430 Rindge Ave
366 BLDG 0.0 0.0 0.0 0.0 0.0 59-26 2023 2023-09-19 2023-09-19 13131.598298 556.556741 POLYGON Z ((447275.214 155023.963 0, 447279.89... 0 Rindge Ave & Alewife Brook Pkwy, Cambridge, Ma... P#002 Rindge Ave @ Alewife Brook Pkwy (solar power, ... Rindge Ave & Alewife Brook Pkwy, Cambridge, Ma... solar power, city traffic signal 432 Rindge Ave
367 BLDG 26.4 46.1 55.9 19.7 29.5 72-8 2025 2020-04-27 2025-08-06 1684.787599 169.526712 POLYGON Z ((448574.684 154850.373 0, 448576.06... 6 Rindge Ave & Pemberton St, Cambridge, Massachu... P#008 Rindge Ave @ Pemberton St (solar power, city l... Rindge Ave & Pemberton St, Cambridge, Massachu... solar power, city light pole 2161 Massachusetts Ave
368 BLDG 26.4 46.1 55.9 19.7 29.5 72-8 2025 2020-04-27 2025-08-06 1684.787599 169.526712 POLYGON Z ((448574.684 154850.373 0, 448576.06... 6 Rindge Ave & Pemberton St, Cambridge, Massachu... P#008 Rindge Ave @ Pemberton St (solar power, city l... Rindge Ave & Pemberton St, Cambridge, Massachu... solar power, city light pole 2 Milton St

369 rows × 20 columns

Code
buildings_within_buffer.explore(color = "red")
Make this Notebook Trusted to load map: File -> Trust Notebook
Code
buildings_within_buffer.to_csv(
    os.path.join(
        csv_output_folder,
        "buildings_within_flock_sites_buffers.csv"
    ),
    index = False
)

Buildings Intersecting 300 feet of a Flock Site

We use spatial joins to test whether the buildings intersect a flock site buffer zone. Again, we then add the full address using the building identifier column “BldgID”.

Code
buildings_intersects_buffer = gpd.sjoin(
    buildings_gdf, 
    flock_gdf, 
    how = 'inner', 
    predicate = 'intersects'
).merge(address_df, on = "BldgID", how = "left")
Code
buildings_intersects_buffer.shape
(670, 20)
Code
buildings_intersects_buffer
TYPE BASE_ELEV ELEV_SL TOP_SL ELEV_GL TOP_GL BldgID EditDate created_da last_edite Shape_area Shape_len geometry index_right address site description flock_site_address flock_site_description Full_Addr
0 OUTBLDG 12.2 19.0 19.8 6.8 7.6 999-413 None 2020-04-27 2021-10-20 87.508135 37.605144 POLYGON Z ((450990.335 152252.156 18.965, 4509... 8 Windsor St & Hampshire St, Cambridge, Massachu... P#010 Windsor St@ Hampshire St (solar power, city li... Windsor St & Hampshire St, Cambridge, Massachu... solar power, city light pole NaN
1 OUTBLDG 12.2 20.6 21.4 8.4 9.2 999-416 None 2020-04-27 2021-10-20 377.143740 77.549984 POLYGON Z ((451069.08 152255.79 20.575, 451071... 8 Windsor St & Hampshire St, Cambridge, Massachu... P#010 Windsor St@ Hampshire St (solar power, city li... Windsor St & Hampshire St, Cambridge, Massachu... solar power, city light pole NaN
2 OUTBLDG 12.5 19.5 19.8 7.0 7.3 999-418 None 2020-04-27 2021-10-20 59.103156 30.780367 POLYGON Z ((451036.689 152257.485 19.547, 4510... 8 Windsor St & Hampshire St, Cambridge, Massachu... P#010 Windsor St@ Hampshire St (solar power, city li... Windsor St & Hampshire St, Cambridge, Massachu... solar power, city light pole NaN
3 OUTBLDG 12.1 19.1 19.2 7.0 7.1 999-424 None 2020-04-27 2021-10-20 249.495638 65.515697 POLYGON Z ((451069.08 152255.79 19.135, 451065... 8 Windsor St & Hampshire St, Cambridge, Massachu... P#010 Windsor St@ Hampshire St (solar power, city li... Windsor St & Hampshire St, Cambridge, Massachu... solar power, city light pole NaN
4 OUTBLDG 12.6 23.4 23.2 10.8 10.6 999-437 None 2020-04-27 2021-10-20 448.830772 87.314311 POLYGON Z ((451063.922 152264.869 23.387, 4510... 8 Windsor St & Hampshire St, Cambridge, Massachu... P#010 Windsor St@ Hampshire St (solar power, city li... Windsor St & Hampshire St, Cambridge, Massachu... solar power, city light pole NaN
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
665 BLDG 0.0 0.0 0.0 0.0 0.0 59-26 2023 2023-09-19 2023-09-19 13131.598298 556.556741 POLYGON Z ((447275.214 155023.963 0, 447279.89... 0 Rindge Ave & Alewife Brook Pkwy, Cambridge, Ma... P#002 Rindge Ave @ Alewife Brook Pkwy (solar power, ... Rindge Ave & Alewife Brook Pkwy, Cambridge, Ma... solar power, city traffic signal 430 Rindge Ave
666 BLDG 0.0 0.0 0.0 0.0 0.0 59-26 2023 2023-09-19 2023-09-19 13131.598298 556.556741 POLYGON Z ((447275.214 155023.963 0, 447279.89... 0 Rindge Ave & Alewife Brook Pkwy, Cambridge, Ma... P#002 Rindge Ave @ Alewife Brook Pkwy (solar power, ... Rindge Ave & Alewife Brook Pkwy, Cambridge, Ma... solar power, city traffic signal 432 Rindge Ave
667 BLDG 0.0 0.0 0.0 0.0 0.0 509-17 2025 2025-07-07 2025-07-07 1978.766909 184.985884 POLYGON Z ((450907.627 152147.147 0, 450900.99... 8 Windsor St & Hampshire St, Cambridge, Massachu... P#010 Windsor St@ Hampshire St (solar power, city li... Windsor St & Hampshire St, Cambridge, Massachu... solar power, city light pole 35 Market St
668 BLDG 26.4 46.1 55.9 19.7 29.5 72-8 2025 2020-04-27 2025-08-06 1684.787599 169.526712 POLYGON Z ((448574.684 154850.373 0, 448576.06... 6 Rindge Ave & Pemberton St, Cambridge, Massachu... P#008 Rindge Ave @ Pemberton St (solar power, city l... Rindge Ave & Pemberton St, Cambridge, Massachu... solar power, city light pole 2161 Massachusetts Ave
669 BLDG 26.4 46.1 55.9 19.7 29.5 72-8 2025 2020-04-27 2025-08-06 1684.787599 169.526712 POLYGON Z ((448574.684 154850.373 0, 448576.06... 6 Rindge Ave & Pemberton St, Cambridge, Massachu... P#008 Rindge Ave @ Pemberton St (solar power, city l... Rindge Ave & Pemberton St, Cambridge, Massachu... solar power, city light pole 2 Milton St

670 rows × 20 columns

Code
buildings_intersects_buffer.explore(color = "red")
Make this Notebook Trusted to load map: File -> Trust Notebook
Code
buildings_intersects_buffer.to_csv(
    os.path.join(
        csv_output_folder,
        "buildings_intersects_flock_sites_buffers.csv"
    ),
    index = False
)